UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vIOiS2SqfCwTBczGeoP6VdDMZ5sJRJ6vlhFCe22YJKQ=' 
WHERE 
  key_id = '643562a5d6a69f2ce4df87261f5da2b40b3a87c21a4234b451a1272d1e3cca40' 
  AND (
    token = 'vIOiS2SqfCwTBczGeoP6VdDMZ5sJRJ6vlhFCe22YJKQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026