UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'U8k9nYy7YoXY1PY/6g94OB+g5MLntx90GjJDmmjh1ZM=' 
WHERE 
  key_id = '8087f2f207e6fe1fa062d254ffe5521986685e06b19b9d76e2ce905996895100' 
  AND (
    token = 'U8k9nYy7YoXY1PY/6g94OB+g5MLntx90GjJDmmjh1ZM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034