UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bI8bAxLMX0vlbgI/a86g+ax7IeZETKM9f+s5dc5/oYo='
WHERE
key_id = '8f9985a8d47871a2cd36dbb7bad15ff1a907b5d3eca6b6b4c4991e82bf0049c8'
AND (
token = 'bI8bAxLMX0vlbgI/a86g+ax7IeZETKM9f+s5dc5/oYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)