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