UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ibf6zM8AJ3rXs5dBifL+XNjPpe7ehLGwqnUqGcPFYOk=' 
WHERE 
  key_id = '69740b200f6afdc505338394b6ae5be04e3180d031982ed9e436835f9074437b' 
  AND (
    token = 'ibf6zM8AJ3rXs5dBifL+XNjPpe7ehLGwqnUqGcPFYOk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035