UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'L6Ev0+K2HUdpNLo8zhJhPf02xKqTa0kdxqEcIuuhGbw=' 
WHERE 
  key_id = 'bed4c7a27c0fdde0b9d06ddcb0af5c0f0f693e59c5433db0266c8c42c6eedd85' 
  AND (
    token = 'L6Ev0+K2HUdpNLo8zhJhPf02xKqTa0kdxqEcIuuhGbw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047