UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iAjJ9MnqPZ38GqaZgg4uXHpehgDZUYQ8MVOcFs7uUz8='
WHERE
key_id = '47d90f92fc2a59f8028c81fc623d55720aa6260c75b32e15388e504a4a113ce9'
AND (
token = 'iAjJ9MnqPZ38GqaZgg4uXHpehgDZUYQ8MVOcFs7uUz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)