UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rx1BTS6g1v7NBnmsj7cgrhz3V/HGKS8iCdVkZn7T12w='
WHERE
key_id = '4c475f96e7d01c1ea38845ecc03688cf37e34bd6f9007dcdcc5b355da435b218'
AND (
token = 'rx1BTS6g1v7NBnmsj7cgrhz3V/HGKS8iCdVkZn7T12w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)