UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BcZ6mgxIB4mC9EOgO4sPUX9uPHViYEPKb7uv7vArPHM='
WHERE
key_id = '5a0ece967f851cd3f7b167bf9c4e7edccd9abda4753c1c9a27756625e576361c'
AND (
token = 'BcZ6mgxIB4mC9EOgO4sPUX9uPHViYEPKb7uv7vArPHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)