UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LKOx30Bv726bXpIMaUtex3y18OmHdKltfguJhK6uxD4='
WHERE
key_id = '83534f89ab7333b7d59ad16cd99cba4c9b0ff193b7eea9c6d5afd896acc3f3ce'
AND (
token = 'LKOx30Bv726bXpIMaUtex3y18OmHdKltfguJhK6uxD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)