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