UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EOLV4AjAv9uJ3HaFeh0ptIwM5LRq5tXhgSPlnUFHcqU='
WHERE
key_id = 'c7f39128021a060f494f9ea813204a0688a5b8c8ba9130526a05abdd55bff06e'
AND (
token = 'EOLV4AjAv9uJ3HaFeh0ptIwM5LRq5tXhgSPlnUFHcqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)