UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'agh9qtClwEwX+CK5RwyPqkfqgd7a0fkVfejy0tBHBVE='
WHERE
key_id = 'd8c99b39cd77df4a57b7b056d562ad1c1adb1890e9a3b1999c6765f9233bdad3'
AND (
token = 'agh9qtClwEwX+CK5RwyPqkfqgd7a0fkVfejy0tBHBVE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)