UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zy9BZFo97ussd7dodT0LLJnIGP9FQCprF29iJ8mX5Ek='
WHERE
key_id = '94f0b1fd7be5a992ed899ceba153286e1e449f95374011d9d5acfa2f32a1598e'
AND (
token = 'zy9BZFo97ussd7dodT0LLJnIGP9FQCprF29iJ8mX5Ek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)