UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'e4h0ZfZjd+3ycWO9U12xtBgidGWlVQLjci/m9m49f8g=' 
WHERE 
  key_id = '0177e947ef5c624e283151e2a0d90baa8d65bda761a1c90b6678f58a25fb8f75' 
  AND (
    token = 'e4h0ZfZjd+3ycWO9U12xtBgidGWlVQLjci/m9m49f8g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026