UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P8Y/MJGQcx6+pnb0QG9MSxC2dq4yBNbeXa+VKNuwyUg='
WHERE
key_id = '219a6a04ee4cd064fa06c915f4a5a5a8dff039fd69faf19cc16b99c72eb7787f'
AND (
token = 'P8Y/MJGQcx6+pnb0QG9MSxC2dq4yBNbeXa+VKNuwyUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)