UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v22JaOhvVMwFKgkfnv3y9YaAlxk5MooHo05aiG30rw4='
WHERE
key_id = '1cda8ea9a5ed0183b2e6331a908503df980630d51feef00624e8c462e3dd96d6'
AND (
token = 'v22JaOhvVMwFKgkfnv3y9YaAlxk5MooHo05aiG30rw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)