UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zxpIzAEDqqRrNZTR+nNJZM+SGhUmJdfVsORB6p178Q8='
WHERE
key_id = 'bc060ef59409daaa487c6f4a2d35fc40058bf0c8653dc8b6529ac5533f6835a1'
AND (
token = 'zxpIzAEDqqRrNZTR+nNJZM+SGhUmJdfVsORB6p178Q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)