UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4047wPq4eYU5t3jdkgcMkMgTJj5e2EmevnF4zNwENwM=' 
WHERE 
  key_id = 'a666e08cb9fce2be0ef415589b18d09afbab97b8684f73c1f80fde86ebda8178' 
  AND (
    token = '4047wPq4eYU5t3jdkgcMkMgTJj5e2EmevnF4zNwENwM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035