UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eFgEDT9ezopOTh7uV7vrteVyE0KzffNxiTZH9zcwFZ4='
WHERE
key_id = '6e5eb1035de0812acb3dba44ce0859ef78857c26510a5e1a34154c76c5d25aca'
AND (
token = 'eFgEDT9ezopOTh7uV7vrteVyE0KzffNxiTZH9zcwFZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)