UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GCKQEiweYate5OpMkHANFDpEqSBaYBUUvKWOzsbiVvk='
WHERE
key_id = 'a10813d6daaee1f38bdb99c6a266909abe1ebb0a9d6a2a35684e253122ad2369'
AND (
token = 'GCKQEiweYate5OpMkHANFDpEqSBaYBUUvKWOzsbiVvk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)