UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bI7L8PIAMvpWa1PRlgj3WnMAboW4UoShCXZ/TtyLV0I='
WHERE
key_id = '56e77599abb975d0284e680382f0a9d7b4cb8e14c4f2fff655058348c39968c9'
AND (
token = 'bI7L8PIAMvpWa1PRlgj3WnMAboW4UoShCXZ/TtyLV0I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)