UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WmWNjOIL4k2iVzI1Jjc4UC3ENasHzEo2/wWTjRhUTUw=' 
WHERE 
  key_id = 'cf0f9e18cacc74f336f9126aab2172d3741427252bbf24759992c4386d29733d' 
  AND (
    token = 'WmWNjOIL4k2iVzI1Jjc4UC3ENasHzEo2/wWTjRhUTUw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027