UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ua/NZ16gdSFmESZugdHM5qO8kOR4U9UnEwQEzceznu4=' 
WHERE 
  key_id = 'df3ffd8514dd485f600d23298707c59b50d379bcb86002c11fdd516c68dc6dad' 
  AND (
    token = 'ua/NZ16gdSFmESZugdHM5qO8kOR4U9UnEwQEzceznu4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026