UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zxwyiMRcdRdRRL4ErH+V1pQi6v2+F6LhDTTunWrsob0=' 
WHERE 
  key_id = '420dd00095690f0c9266dd12cebbb6173aa951ee6d4f318946c9b811a7b594b2' 
  AND (
    token = 'zxwyiMRcdRdRRL4ErH+V1pQi6v2+F6LhDTTunWrsob0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036