UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NO7Zq7DdN/WlqaT4otTEuTAJBdKH3e3D8A/KZHI3mbM=' 
WHERE 
  key_id = '2f2f2a42928c56a0f452a01b176dea16bbe38f6b13bf99e11227f77365bc2aed' 
  AND (
    token = 'NO7Zq7DdN/WlqaT4otTEuTAJBdKH3e3D8A/KZHI3mbM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030