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