UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'd6e1jh/YBgamx/8szC3p/IOwmP+cP41CJHccQoSGkEA=' 
WHERE 
  key_id = '21efaf71363114631b823e67580690c35321f408032ae586f898cf810cb9915e' 
  AND (
    token = 'd6e1jh/YBgamx/8szC3p/IOwmP+cP41CJHccQoSGkEA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041