UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bzD/7EZ/rzVLunk+7FitlUqH0Yhveba4pFrjH93V5og='
WHERE
key_id = 'c370b2e6389f5a615b10b46460dc137381a1ccf85136376977b51f651b634f46'
AND (
token = 'bzD/7EZ/rzVLunk+7FitlUqH0Yhveba4pFrjH93V5og='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)