UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Cmc0m8HipIqbQC96M/fRGHZvX9jaTuX5NeebA9nDZPk='
WHERE
key_id = 'c2cc75990f9e7ddd3bb9b6a27c39f53eb16333682e43fed34d57e6174f4fb717'
AND (
token = 'Cmc0m8HipIqbQC96M/fRGHZvX9jaTuX5NeebA9nDZPk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)