UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XtRb9RQwoAJS/DNIqHrFVKLI7qNoR5RXaO0Gz7Ho40A='
WHERE
key_id = 'd572bbb1b6f40d6501e0357ef7b123f43eb49e08ec5eb4426c25d1be3c8ee957'
AND (
token = 'XtRb9RQwoAJS/DNIqHrFVKLI7qNoR5RXaO0Gz7Ho40A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)