UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4JbFZ7koGvm0SMbViKHHfui5ib6RF0tTzEzTN3qwpn4='
WHERE
key_id = 'a27e2c715c5fe43b82634295278dccd063e0c48ee413eac51b92289333bc6825'
AND (
token = '4JbFZ7koGvm0SMbViKHHfui5ib6RF0tTzEzTN3qwpn4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)