UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '++MHVJCxxJ7o9r4BoX60STANwYYfSs+Ysjrgjz9qodI=' 
WHERE 
  key_id = 'a43d5cbc6cd8b4bc11340c83a138d07ec2140f0b3817c9e0a89a17a3fd3d42ad' 
  AND (
    token = '++MHVJCxxJ7o9r4BoX60STANwYYfSs+Ysjrgjz9qodI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022